if exists (select * from sysobjects where (sysobjects.uid = 9 or sysobjects.uid = 11) and "Name" = 'TRF_INSERT_EXAMPLE')
begin
      DROP PROCEDURE TRF_INSERT_EXAMPLE;
end

GO
CREATE PROCEDURE TRF_INSERT_EXAMPLE
AS
BEGIN
	insert into TRF_TARIFF values(1,'START',2,1,6,4);
        insert into TRF_TARIFF values(2,'CHRISTMAS',1,2,6,4); 
        insert into TRF_TARIFF values(3,'LIGHT',1,1,6,4);
        insert into TRF_TARIFF values(4,'ROAMING_LIGHT',2,2,2,2);

	EXEC TRF_INSERT_ACCOUNT 'CLIENT1', 140123456, 1234567, 1, 100;
	EXEC TRF_INSERT_ACCOUNT 'CLIENT1', 140123456, 1234568, 2, 150;
	EXEC TRF_INSERT_ACCOUNT 'CLIENT1', 140123456, 1234569, 3, 100;
	EXEC TRF_INSERT_ACCOUNT 'CLIENT2', 440123457, 1234570, 1, 100;
	EXEC TRF_INSERT_ACCOUNT 'CLIENT2', 440123457, 1234571, 2, 150;
	EXEC TRF_INSERT_ACCOUNT 'CLIENT3', 640123458, 1234572, 1, 100;
	EXEC TRF_INSERT_ACCOUNT 'CLIENT3', 640123458, 1234573, 2, 150;
	EXEC TRF_INSERT_ACCOUNT 'CLIENT4', 840123459, 1234574, 1, 100;
	EXEC TRF_INSERT_ACCOUNT 'CLIENT5', 940123460, 1234575, 1, 150;
	EXEC TRF_INSERT_ACCOUNT 'CLIENT6', 140123461, 1234576, 1, 100;
	EXEC TRF_INSERT_ACCOUNT 'CLIENT7', 240123462, 1234577, 3, 150;
	EXEC TRF_INSERT_ACCOUNT 'CLIENT8', 340123463, 1234578, 1, 100;
END

EXEC TRF_INSERT_EXAMPLE;